Clear a data table

1. Select the entire data table, including all formulas, input values, resulting values, formats, and comments.
2. On the Edit menu, point to Clear, and then click All.

Note  Because resulting values are in an array, you must clear all values. Unless you want to clear the entire data table, make sure that you do not select the formulas and input values.

1. Select all resulting values in the data table.
2. On the Edit menu, point to Clear, and then click Contents.